﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'operarioAdd')
	BEGIN
		DROP  Procedure  operarioAdd
	END
GO

CREATE PROCEDURE [dbo].[operarioAdd] 	
	(	
		@empresa_id AS INT,
		@nombre AS VARCHAR(50),
		@puesto_id AS INT,
		@costo_hora AS MONEY
	)	
AS
BEGIN	
	SET NOCOUNT ON
	
	INSERT INTO Lit_Operario (EmpresaId, Nombre, PuestoId, CostoxHora, Activo)
	VALUES (@empresa_id, @nombre, @puesto_id, @costo_hora, 1)  
		
	SET NOCOUNT OFF
END
GO